orcli search

apply regex to each column and print matches in flattened tsv format output: index column value note that any exporter supports search by using --facets (see examples)

Usage

Arguments
project name or id
(required)
search term (regular expression, case-sensitive)
Options
print column values instead of row.index in the first column of the output
Parent Environment Variables
URL to OpenRefine server

Examples

orcli search "duplicates" "^Ben"
orcli search 1234567890123 "^Ben"
orcli search "duplicates" "^F" --index "email"
orcli search "duplicates" | column -t -s $'\t'
orcli export tsv "duplicates" --facets '[{ "type": "list", "expression": "grel:filter(row.columnNames,cn,cells[cn].value.find(/^Ben/).length()>0).length()>0", "columnName": "", "selection": [{"v": {"v": true}}] }]'
orcli export tsv "duplicates" --facets '[{ "type": "list", "expression": "grel:filter([\"gender\",\"purchase\"],cn,cells[cn].value.find(/^F/).length()>0).length()>0", "columnName": "", "selection": [{"v": {"v": true}}] }]'